NTISthis.com

Evidence Guide: BSBADM403A - Develop and use complex databases

Student: __________________________________________________

Signature: _________________________________________________

Tips for gathering evidence to demonstrate your skills

The important thing to remember when gathering evidence is that the more evidence the better - that is, the more evidence you gather to demonstrate your skills, the more confident an assessor can be that you have learned the skills not just at one point in time, but are continuing to apply and develop those skills (as opposed to just learning for the test!). Furthermore, one piece of evidence that you collect will not usualy demonstrate all the required criteria for a unit of competency, whereas multiple overlapping pieces of evidence will usually do the trick!

From the Wiki University

 

BSBADM403A - Develop and use complex databases

What evidence can you provide to prove your understanding of each of the following citeria?

Use safe work practices

  1. Workspace, furniture and equipment are adjusted to suit the ergonomic requirements of the user
  2. Work organisation meets organisational and statutory requirements for computer operation
  3. Energy and resource conservation techniques are used to minimise wastage in accordance with organisational and statutory requirements
Workspace, furniture and equipment are adjusted to suit the ergonomic requirements of the user

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Work organisation meets organisational and statutory requirements for computer operation

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Energy and resource conservation techniques are used to minimise wastage in accordance with organisational and statutory requirements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Develop a linked database solution

  1. Task is analysed and specifications for databases are determined
  2. Organisational and task requirements in relation to data entry, storage, output, reporting and presentation requirements are identified
  3. Databases are designed and constructed to meet the requirements of the given situation
  4. Field attributes are set according to data type and databases are linked by a common field in accordance with software procedures
  5. Database design utilises software functions and formulae to meet identified requirements
Task is analysed and specifications for databases are determined

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Organisational and task requirements in relation to data entry, storage, output, reporting and presentation requirements are identified

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Databases are designed and constructed to meet the requirements of the given situation

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Field attributes are set according to data type and databases are linked by a common field in accordance with software procedures

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Database design utilises software functions and formulae to meet identified requirements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Develop database record forms and reports

  1. Data entry forms are designed and created to meet specified requirements for entering and displaying information
  2. Data table and form layout enable efficient data input and display
  3. Field attributes are set according to data type and formulae / calculated field incorporated to meet task specifications
  4. Report formats are designed and c reated according to specified criteria using conditional operators as required
  5. Database reports are formatted in accordance with organisational style and presentation requirements
  6. Queries and formulae are tested to confirm output meets task requirements
Data entry forms are designed and created to meet specified requirements for entering and displaying information

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Data table and form layout enable efficient data input and display

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Field attributes are set according to data type and formulae / calculated field incorporated to meet task specifications

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Report formats are designed and c reated according to specified criteria using conditional operators as required

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Database reports are formatted in accordance with organisational style and presentation requirements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Queries and formulae are tested to confirm output meets task requirements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Automate and standardise database operation

  1. Tasks are evaluated to identify those where automation would increase efficiency
  2. Macros are created, used and edited to fulfil the requirements of the task and automate database operation
  3. Templates are developed, edited and used to ensure consistency of design and layout for forms and reports in accordance with organisational requirements
Tasks are evaluated to identify those where automation would increase efficiency

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Macros are created, used and edited to fulfil the requirements of the task and automate database operation

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Templates are developed, edited and used to ensure consistency of design and layout for forms and reports in accordance with organisational requirements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Use databases

  1. Data is entered, checked and amended in accordance with organisational and task requirements
  2. Data is imported / exported between compatible databases and host documents adjusted in accordance with software and system procedures
  3. Manuals, user documentation and on-line help are used to overcome problems with spreadsheet design and production
  4. Database reports and/or forms are previewed, adjusted and printed in accordance with organisational and task requirements
  5. Database is named and stored, in accordance with organisational requirements and the application exited without data loss/damage
Data is entered, checked and amended in accordance with organisational and task requirements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Data is imported / exported between compatible databases and host documents adjusted in accordance with software and system procedures

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Manuals, user documentation and on-line help are used to overcome problems with spreadsheet design and production

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Database reports and/or forms are previewed, adjusted and printed in accordance with organisational and task requirements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Database is named and stored, in accordance with organisational requirements and the application exited without data loss/damage

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Assessed

Teacher: ___________________________________ Date: _________

Signature: ________________________________________________

Comments:

 

 

 

 

 

 

 

 

Instructions to Assessors

Evidence Guide

The Evidence Guide identifies the critical aspects, underpinning knowledge and skills to be demonstrated to confirm competence for this unit. This is an integral part of the assessment of competence and should be read in conjunction with the Range Statement.

Critical Aspects of Evidence

Integrated demonstration of all elements of competency and their performance criteria

Successful operation of linked databases

Knowledge and application of advanced database functions to achieve efficient design of databases

Underpinning Knowledge*

* At this level the learner must demonstrate understanding of a broad knowledge base incorporating some theoretical concepts.

Relevant legislation from all levels of government that affects business operation, especially in regard to Occupational Health and Safety and environmental issues, equal opportunity, industrial relations and anti-discrimination

Advanced functions of database software applications

Impact of formatting and design on the presentation and readability of data

Organisational policies and procedures

Underpinning Skills

Literacy skills to interpret and evaluate the purposes and uses of various features of databases; use a variety of strategies for planning and reviewing own work

Proofreading and editing skills to check for accuracy and consistency of information by consulting additional resources

Problem solving skills to use processes flexibly and interchangeably

Numeracy skills to collate and present data; graphs and related references

Communication skills to follow complex oral instructions when using technology; listen to and interpret complex sequenced instructions

Keyboarding skills

Ability to relate to people from a range of social, cultural and ethnic backgrounds and physical and mental abilities

Resource Implications

The learner and trainer should have access to appropriate documentation and resources normally used in the workplace which may include:

workplace references such as computer user manuals, organisational policies and procedures and workplace procedural manuals

computer equipment including relevant software, printer

guide/examples of 'house style'

equipment (eg paper and other materials)

Consistency of Performance

In order to achieve consistency of performance, evidence should be collected over a set period of time which is sufficient to include dealings with an appropriate range and variety of situations

Context/s of Assessment

Competency is demonstrated by performance of all stated criteria, including paying particular attention to the critical aspects and the knowledge and skills elaborated in the Evidence Guide, and within the scope as defined by the Range Statement

Assessment must take account of the endorsed assessment guidelines in the Business Services Training Package

Assessment of performance requirements in this unit should be undertaken in an actual workplace or simulated environment

Assessment should reinforce the integration of the key competencies and the business services common competencies for the particular AQF level. Refer to the Key Competency Levels at the end of this unit

Key Competency Levels

Collecting, analysing and organising information (Level 2)- to determine database requirements

Communicating ideas and information (Level 1)- through well-designed records and reports

Planning and organising activities (Level 1)- to link databases and meet task specifications

Working with teams and others (Level 1)- to determine database purpose / use

Using mathematical ideas and techniques (Level 1)- to utilise formulae and calculate fields

Solving problems (Level 2)- using manuals and on-line help

Using technology (Level 2)- to develop and use complex databases

Please refer to the Assessment Guidelines for advice on how to use the Key Competencies

The Evidence Guide identifies the critical aspects, underpinning knowledge and skills to be demonstrated to confirm competence for this unit. This is an integral part of the assessment of competence and should be read in conjunction with the Range Statement.

Critical Aspects of Evidence

Integrated demonstration of all elements of competency and their performance criteria

Successful operation of linked databases

Knowledge and application of advanced database functions to achieve efficient design of databases

Underpinning Knowledge*

* At this level the learner must demonstrate understanding of a broad knowledge base incorporating some theoretical concepts.

Relevant legislation from all levels of government that affects business operation, especially in regard to Occupational Health and Safety and environmental issues, equal opportunity, industrial relations and anti-discrimination

Advanced functions of database software applications

Impact of formatting and design on the presentation and readability of data

Organisational policies and procedures

Underpinning Skills

Literacy skills to interpret and evaluate the purposes and uses of various features of databases; use a variety of strategies for planning and reviewing own work

Proofreading and editing skills to check for accuracy and consistency of information by consulting additional resources

Problem solving skills to use processes flexibly and interchangeably

Numeracy skills to collate and present data; graphs and related references

Communication skills to follow complex oral instructions when using technology; listen to and interpret complex sequenced instructions

Keyboarding skills

Ability to relate to people from a range of social, cultural and ethnic backgrounds and physical and mental abilities

Resource Implications

The learner and trainer should have access to appropriate documentation and resources normally used in the workplace which may include:

workplace references such as computer user manuals, organisational policies and procedures and workplace procedural manuals

computer equipment including relevant software, printer

guide/examples of 'house style'

equipment (eg paper and other materials)

Consistency of Performance

In order to achieve consistency of performance, evidence should be collected over a set period of time which is sufficient to include dealings with an appropriate range and variety of situations

Context/s of Assessment

Competency is demonstrated by performance of all stated criteria, including paying particular attention to the critical aspects and the knowledge and skills elaborated in the Evidence Guide, and within the scope as defined by the Range Statement

Assessment must take account of the endorsed assessment guidelines in the Business Services Training Package

Assessment of performance requirements in this unit should be undertaken in an actual workplace or simulated environment

Assessment should reinforce the integration of the key competencies and the business services common competencies for the particular AQF level. Refer to the Key Competency Levels at the end of this unit

Key Competency Levels

Collecting, analysing and organising information (Level 2)- to determine database requirements

Communicating ideas and information (Level 1)- through well-designed records and reports

Planning and organising activities (Level 1)- to link databases and meet task specifications

Working with teams and others (Level 1)- to determine database purpose / use

Using mathematical ideas and techniques (Level 1)- to utilise formulae and calculate fields

Solving problems (Level 2)- using manuals and on-line help

Using technology (Level 2)- to develop and use complex databases

Please refer to the Assessment Guidelines for advice on how to use the Key Competencies

Required Skills and Knowledge

Not applicable.

Range Statement

The Range Statement provides advice to interpret the scope and context of this unit of competence, allowing for differences between enterprises and workplaces. It relates to the unit as a whole and facilitates holistic assessment. The following variables may be present for this particular unit:

Legislation, codes and national standards relevant to the workplace which may include:

award and enterprise agreements and relevant industrial instruments

relevant legislation from all levels of government that affects business operation, especially in regard to Occupational Health and Safety and environmental issues, equal opportunity, industrial relations and anti-discrimination

relevant industry codes of practice

Organisational policy and procedures may include:

log-on procedures

password protection

storage / location of data

standard formats

author's instructions

use of templates

Ergonomic requirements may include:

workstation height and layout

chair height, seat and back adjustment

footrest

screen position

keyboard and mouse position

document holder

posture

avoiding radiation from computer screens

lighting

noise minimisation

Work organisation may include:

mix of repetitive and other activities

rest periods

exercise breaks

Conservation techniques may include:

double-sided paper use

re-used paper for rough drafts (observing confidentiality requirements)

recycling used and shredded paper

utilising power-save options for equipment

Database design may include:

Analysis

Appropriateness

field attributes

formulae (if required)

functions (if available)

format

entry and validation of data

importing and exporting data

linking fields

formatting and reformatting

split screen operation (if available)

Formulae may include:

Addition

Subtraction

Multiplication

Division

Maximum

Minimum

Average

combinations of above

Data entry form creation may include:

field definitions

record layout

format

blank lines and spaces

insert

delete

titles

fields:

alter widths

move

re-label

add

delete

repeating (if available)

calculate/formula

Reports may include:

Query

selection criteria

conditional operators (and, or, not)

record selection

format

field selection

headers and footers (if available)

Macro selection options may include:

Append

Edit

Query

List

Delete

Report

Print

Exit

Templates may include:

Forms

Reports

headers/footers

page formats

font types and sizes

headings

Printing may include:

Records

Tables

Forms

Queries

Reports

Storage of data may include:

storage in folders / sub-folders

storage on hard/floppy disk drives, CDROM, tape backup

organisation policy for backing up files

organisation policy for filing hard copies of spreadsheets

filing locations

security

authorised access

The Range Statement provides advice to interpret the scope and context of this unit of competence, allowing for differences between enterprises and workplaces. It relates to the unit as a whole and facilitates holistic assessment. The following variables may be present for this particular unit:

Legislation, codes and national standards relevant to the workplace which may include:

award and enterprise agreements and relevant industrial instruments

relevant legislation from all levels of government that affects business operation, especially in regard to Occupational Health and Safety and environmental issues, equal opportunity, industrial relations and anti-discrimination

relevant industry codes of practice

Organisational policy and procedures may include:

log-on procedures

password protection

storage / location of data

standard formats

author's instructions

use of templates

Ergonomic requirements may include:

workstation height and layout

chair height, seat and back adjustment

footrest

screen position

keyboard and mouse position

document holder

posture

avoiding radiation from computer screens

lighting

noise minimisation

Work organisation may include:

mix of repetitive and other activities

rest periods

exercise breaks

Conservation techniques may include:

double-sided paper use

re-used paper for rough drafts (observing confidentiality requirements)

recycling used and shredded paper

utilising power-save options for equipment

Database design may include:

Analysis

Appropriateness

field attributes

formulae (if required)

functions (if available)

format

entry and validation of data

importing and exporting data

linking fields

formatting and reformatting

split screen operation (if available)

Formulae may include:

Addition

Subtraction

Multiplication

Division

Maximum

Minimum

Average

combinations of above

Data entry form creation may include:

field definitions

record layout

format

blank lines and spaces

insert

delete

titles

fields:

alter widths

move

re-label

add

delete

repeating (if available)

calculate/formula

Reports may include:

Query

selection criteria

conditional operators (and, or, not)

record selection

format

field selection

headers and footers (if available)

Macro selection options may include:

Append

Edit

Query

List

Delete

Report

Print

Exit

Templates may include:

Forms

Reports

headers/footers

page formats

font types and sizes

headings

Printing may include:

Records

Tables

Forms

Queries

Reports

Storage of data may include:

storage in folders / sub-folders

storage on hard/floppy disk drives, CDROM, tape backup

organisation policy for backing up files

organisation policy for filing hard copies of spreadsheets

filing locations

security

authorised access